Returns a list of all dates in the given year beginning from the specified start month and day, derived from the specified date-time.
Syntax & Usage
A PQL expression that returns a single member element. The member must exist in the data source; it cannot be a custom member. For the YTD function, this should be a member from the dateKey hierarchy; the given member will be the last date in the list.
A numeric value that determines which month the list should start from; this value is set to 1 by default. Change this value from the Insert Arguments window under 'Month of year to start from'.
A numeric value that determines which day of the first month the list should start from; this value is set to 1 by default. Change this value from the Insert Arguments window under 'Day of month to start from'.
Example
The dateKey 2008-04-30 is selected, and both integer values are 1, returning a list of all dates from 2008-01-01up to and including 2008-12-31:
{FullYear([data].[dateKey].[1209513600000],1,1)}
Here, the model member is still 2008-04-30, but the start month is 3 and the start day is 10; the set returned lists all dates starting from 2008-03-10 up to and including 2009-03-09:
{FullYear([data].[dateKey].[1209513600000],3,10)}
